Merge records

During data migration or perhaps due to data entry errors there may be two or more records in a module for the same Party, event, etc. In this case it is desirable to identify the master record and delete the unnecessary records. If other records attach to the obsolete records, it is first necessary to ensure that these attachments are switched to the master record.

Note: It is not possible to delete a record while it is referenced by another record. The Merge records function shifts any attachments that have been made to the obsolete records to the master record and allows the obsolete records to be deleted.

For example, you find that there are several records in the Parties module for the same person, e.g. J. Smith, John K Smith and John Smith. You decide that the master record is John Smith and the other two records can be deleted. Before they can be deleted however any records that attach to them must be updated to attach to the master record.

Using the Merge Records tool authorised users can:

  1. Specify which is the correct record: John Smith in this example.
  2. Ensure that any other records that attach to the obsolete records (J. Smith and John K Smith in this example ) attach to the correct record.

The obsolete records can then be deleted.

This is a specialised form of the Global Replace function.

Note: Note that the Merge records function does not merge data in the obsolete records with the master record. For example if the J. Smith record has an address that is valid for the John Smith record, it is necessary to copy and paste the address manually into the John Smith record before merging the records.

How to merge records

  1. Search for the records to be merged.
  2. Select the record or records that are to be merged with the master record:

    In this example the selected records will be merged with the record at the top of the list.

  3. Select Edit>Merge>Current if only the current record is to be merged

    -OR-

    Select Edit>Merge>Selected to merge the selected records (as in the example above).

    A second copy of the module opens.

  4. Search for and select the record that will replace the record(s) selected at Step 3.
  5. Click Attach Attach Current Record in the Tool bar.

    A prompt will display asking whether to proceed with the merge.

  6. Click Yes to display the Merging box.

    The Merging box shows the process of the update (this includes any records attached to the records being merged):

  7. Once the obsolete records have been merged, it is possible to delete them.